清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

can i get a program for this excel file..?

1 次查看（过去 30 天）
nani kalyan
nani kalyan 2015-5-27
关闭： MATLAB Answer Bot 2021-8-20
here i am having so many values in the excel file.Now, in that column it should check each value with following values:
a) 0<=power>=56, the value should multiply with the 0.925 that means power*0.925.
a) 57<=power>=112, the value should multiply with the 0.925 that means power*0.952.
a) 113<=power>=168, the value should multiply with the 0.925 that means power*0.958.
a) 169<=power>=225, the value should multiply with the 0.925 that means power*0.959.
Similarly, i need to get the all values in that column should be check.

此问题已关闭。

回答（1 个）

Walter Roberson
Walter Roberson 2015-5-27
powerfactor = [0.925, 0.952, 0.958, 0.959]);
[count, binnum] = histc(power, [-inf, 57, 113, 169, inf]);
adjpower = power .* powerfactor(binnum);
Note: you have not defined what should happen between 56 and 57, or between 112 and 113, and so on. And you have not defined what should happen for below 0 or above 225.
  1 个评论
nani kalyan
nani kalyan 2015-5-27
编辑：nani kalyan 2015-5-27
Error in .^ (line 8) [count, binnum] = histc(power, [-inf, 57, 113, 169, inf]);
Note: i have attached the excel file in that i have the max. value is 225 and the minimum values is 0. so, no need to find the below values.

此问题已关闭。

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by